/*
 Navicat Premium Data Transfer

 Source Server         : localhost(SqlSever)
 Source Server Type    : SQL Server
 Source Server Version : 14002037
 Source Host           : localhost:1433
 Source Catalog        : jherp
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 14002037
 File Encoding         : 65001

 Date: 07/06/2022 15:55:20
*/


-- ----------------------------
-- Table structure for sp_delivery_details
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_delivery_details]') AND type IN ('U'))
	DROP TABLE [dbo].[sp_delivery_details]
GO

CREATE TABLE [dbo].[sp_delivery_details] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [master_id] char(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [cinv_code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [cinv_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [cinv_std] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ccom_unit_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [current_delivery_qty] numeric(18)  NULL,
  [itax_price] decimal(20,2)  NULL,
  [amount] decimal(20,2)  NULL,
  [memo] text COLLATE Chinese_PRC_CI_AS  NULL,
  [purchase_code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [purchase_detail_id] int  NULL,
  [batch] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [act_qty] numeric(18)  NULL,
  [purchase_master_id] int  NULL,
  [cexch_name] varchar(10) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sp_delivery_details] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主表id',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'master_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存货编码',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'cinv_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存货名称',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'cinv_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'规格型号',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'cinv_std'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单位',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'ccom_unit_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数量',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'current_delivery_qty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单价',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'itax_price'
GO

EXEC sp_addextendedproperty
'MS_Description', N'金额',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'amount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'memo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'采购订单号',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'purchase_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'采购订单子表id',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'purchase_detail_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'批次号',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'batch'
GO

EXEC sp_addextendedproperty
'MS_Description', N'实际到货数量',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'act_qty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'采购订单主表id',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'purchase_master_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'币种',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_details',
'COLUMN', N'cexch_name'
GO


-- ----------------------------
-- Records of sp_delivery_details
-- ----------------------------
INSERT INTO [dbo].[sp_delivery_details] VALUES (N'1d1a8da5f77946d19a92e4d1120f139b', N'ef3dcea6b43b477a8a52aea9c1a61a18', N'101001', N'1号标胶', N'NR1', N'公斤', N'400', N'56.50', N'22600.00', NULL, N'0000026293', N'1000098116', N'400', NULL, N'1000030123', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'1fc176e78c3d46d0ae6e811b34490be4', N'574200bc104341dcadfc26cd33d43793', N'202003', N'缓冲垫支座防尘垫75*28*2', NULL, N'件', N'500', N'15.82', N'7910.00', NULL, N'0000026299', N'1000098141', N'20220530', N'500', N'1000030129', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'20d0d36f009c49aa96949710dd388578', N'5d3ff2ac98cd49f68bbeb5ea863aa64a', N'202004', N'传感器堵塞胶圈(13.7*3)', N'B-1003090-B01', N'件', N'1000', N'19.21', N'19210.00', NULL, N'0000026299', N'1000098142', N'20220531', N'500', N'1000030129', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'26e1f2d723a84df08b814e528dadf3de', N'd80f823d4b2c427db7a12d9306cca0f0', N'101003', N'丁苯橡胶1500', N'SBR1500', N'公斤', N'1550', N'28.25', N'42375.00', NULL, N'0000026293', N'1000098118', N'20220516', N'1550', N'1000030123', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'37bff7798c8a44849c0c727903f2b1bb', N'd80f823d4b2c427db7a12d9306cca0f0', N'101001', N'1号标胶', N'NR1', N'公斤', N'550', N'56.50', N'28250.00', NULL, N'0000026293', N'1000098116', N'20220516', N'550', N'1000030123', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'c5381bc2d7a74402a3e6fe7a55873fb2', N'cb205feb74d14976b705c85e40ae4de7', N'202002', N'油箱装饰条（780）', N'B-12B4188-00', N'件', N'500', N'14.69', N'7345.00', NULL, N'0000026299', N'1000098140', N'20220531', N'500', N'1000030129', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'e08a816b945646fe8b008111bcc32f13', N'ae897152f3774ed5aef239ff1c8bf693', N'101001', N'1号标胶', N'NR1', N'公斤', N'50', N'56.50', N'2825.00', NULL, N'0000026293', N'1000098116', N'60', NULL, N'1000030123', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'e45d8a5153fb4f9ca31cffc085677559', N'9528dc5255ec49d282d874630fb3b21c', N'202004', N'传感器堵塞胶圈(13.7*3)', N'B-1003090-B01', N'件', N'2500', N'19.21', N'48025.00', NULL, N'0000026299', N'1000098142', N'20220531', N'2500', N'1000030129', N'人民币')
GO

INSERT INTO [dbo].[sp_delivery_details] VALUES (N'fa7996f5801b49fc9981f0fc32735828', N'd80f823d4b2c427db7a12d9306cca0f0', N'101002', N'2号标胶', N'NR2', N'公斤', N'1050', N'39.55', N'39550.00', NULL, N'0000026293', N'1000098117', N'20220516', N'1050', N'1000030123', N'人民币')
GO


-- ----------------------------
-- Table structure for sp_delivery_master
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_delivery_master]') AND type IN ('U'))
	DROP TABLE [dbo].[sp_delivery_master]
GO

CREATE TABLE [dbo].[sp_delivery_master] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [delivery_code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [vender_code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [customer_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [delivery_addr] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [contacts] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [customer_tel] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [delivery_date] datetime  NULL,
  [create_user] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime  NULL,
  [memo] text COLLATE Chinese_PRC_CI_AS  NULL,
  [bar_code] text COLLATE Chinese_PRC_CI_AS  NULL,
  [complete_flag] bit  NULL,
  [create_date] date  NULL
)
GO

ALTER TABLE [dbo].[sp_delivery_master] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'送货单号',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'delivery_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'供应商编码',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'vender_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'客户',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'customer_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'送货地址',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'delivery_addr'
GO

EXEC sp_addextendedproperty
'MS_Description', N'联系人',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'contacts'
GO

EXEC sp_addextendedproperty
'MS_Description', N'客户电话',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'customer_tel'
GO

EXEC sp_addextendedproperty
'MS_Description', N'送货日期',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'delivery_date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'制单人',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'create_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'memo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'二维码',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'bar_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'完成标识',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'complete_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'制单日期',
'SCHEMA', N'dbo',
'TABLE', N'sp_delivery_master',
'COLUMN', N'create_date'
GO


-- ----------------------------
-- Records of sp_delivery_master
-- ----------------------------
INSERT INTO [dbo].[sp_delivery_master] VALUES (N'574200bc104341dcadfc26cd33d43793', N'AS2205300003', N'01006', N'重庆江华橡塑制造有限公司', N'esg', N'zbvz', N'123', N'2022-05-31 00:00:00.000', N'1531452233213681666', N'2022-05-31 10:37:22.810', NULL, NULL, N'1', NULL)
GO

INSERT INTO [dbo].[sp_delivery_master] VALUES (N'5d3ff2ac98cd49f68bbeb5ea863aa64a', N'AS2205300004', N'01006', N'重庆江华橡塑制造有限公司', N'szfg', N'asfg', N'123', N'2022-05-31 00:00:00.000', N'1531452233213681666', N'2022-05-31 10:40:53.147', NULL, NULL, N'1', NULL)
GO

INSERT INTO [dbo].[sp_delivery_master] VALUES (N'9528dc5255ec49d282d874630fb3b21c', N'AS2205300005', N'01006', N'重庆江华橡塑制造有限公司', N'xcdb', N'SDfg', N'123', N'2022-05-31 00:00:00.000', N'1531452233213681666', N'2022-05-31 10:44:14.067', NULL, NULL, N'1', NULL)
GO

INSERT INTO [dbo].[sp_delivery_master] VALUES (N'ae897152f3774ed5aef239ff1c8bf693', N'AS2205230002', N'01001', N'重庆江华橡塑制造有限公司', N'44', N'44', N'44', N'2022-05-23 00:00:00.000', N'111', N'2022-05-23 11:00:25.530', NULL, NULL, N'0', NULL)
GO

INSERT INTO [dbo].[sp_delivery_master] VALUES (N'cb205feb74d14976b705c85e40ae4de7', N'AS2205300002', N'01006', N'重庆江华橡塑制造有限公司', N'dsgd', N'cxbdg', N'112345', N'2022-05-31 00:00:00.000', N'1531452233213681666', N'2022-05-31 10:17:28.223', NULL, NULL, N'1', NULL)
GO

INSERT INTO [dbo].[sp_delivery_master] VALUES (N'd80f823d4b2c427db7a12d9306cca0f0', N'AS2205160001', N'01001', N'重庆江华橡塑制造有限公司', N'111', N'111', N'111', N'2022-05-16 00:00:00.000', N'111', N'2022-05-16 14:26:40.710', NULL, NULL, N'1', NULL)
GO

INSERT INTO [dbo].[sp_delivery_master] VALUES (N'ef3dcea6b43b477a8a52aea9c1a61a18', N'AS2205230001', N'01001', N'重庆江华橡塑制造有限公司', N'33', N'33', N'33', N'2022-05-23 00:00:00.000', N'111', N'2022-05-23 10:59:46.617', NULL, NULL, N'0', NULL)
GO


-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dept]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dept]
GO

CREATE TABLE [dbo].[sys_dept] (
  [id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [dept_code] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [dept_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [pid] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(0)  NOT NULL,
  [update_time] datetime2(0)  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_dept] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO [dbo].[sys_dept] VALUES (N'3d23a3270f434b6089bfacd6d818c261', N'100101', N'开发部', N'99f385f20e1e480a9f573a741c693342', N'2021-01-27 11:38:36', N'2021-01-27 11:38:36')
GO

INSERT INTO [dbo].[sys_dept] VALUES (N'99f385f20e1e480a9f573a741c693342', N'1001', N'总经办', N'', N'2020-03-12 16:53:01', N'2020-03-12 16:53:01')
GO


-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_log]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_log]
GO

CREATE TABLE [dbo].[sys_log] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [username] nvarchar(16) COLLATE Chinese_PRC_CI_AS  NULL,
  [operation] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [time] int  NULL,
  [method] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [params] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [ip] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [createTime] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'操作人',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'operation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'时长',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方法',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'method'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'params'
GO

EXEC sp_addextendedproperty
'MS_Description', N'ip地址',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'ip'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'createTime'
GO


-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO [dbo].[sys_log] VALUES (N'1518873861707141122', N'系统管理员', N'添加用户', N'5', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1518873861648420865, userCode=bb, userName=bb, userPhone=22, userAge=22, userSex=女, userAddr=22, userEmail=22, departmentId=99f385f20e1e480a9f573a741c693342, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=c8504a59d8d0cc722f12e0f5b075245d, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-04-26 16:45:22.5880000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1519199167336910849', N'系统管理员', N'修改用户', N'11', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1518871656954466306, userCode=aa, userName=aa, userPhone=11, userAge=11, userSex=男, userAddr=11, userEmail=11, departmentId=3d23a3270f434b6089bfacd6d818c261, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-04-27 14:18:01.4870000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1519199187775754241', N'系统管理员', N'修改用户', N'1', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1518871656954466306, userCode=aa, userName=aa, userPhone=11, userAge=11, userSex=男, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-04-27 14:18:06.3790000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1519199215151976449', N'系统管理员', N'修改用户', N'1', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1518873861648420865, userCode=bb, userName=bb, userPhone=22, userAge=22, userSex=女, userAddr=22, userEmail=22, departmentId=3d23a3270f434b6089bfacd6d818c261, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-04-27 14:18:12.9060000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523947895453061121', N'系统管理员', N'修改菜单', N'13', N'com.xmb.wcapi.controller.MenuController.edit()', N'  sysMenu: SysMenu [id=5c7c36904e004e98b61fefb321c6a6a8, menuName=采购到货, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/purchase_arrival/index, menuIcon=, orderByIndex=2]', N'127.0.0.1', N'2022-05-10 16:47:46.4900000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523950418373054466', N'系统管理员', N'修改按钮', N'32', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:purchaseArrival_update","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"修改（按钮）","menuType":"按钮"}  id: btn:saleTransform_scale', N'127.0.0.1', N'2022-05-10 16:57:48.0320000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523950451600330754', N'系统管理员', N'修改按钮', N'3', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:purchaseArrival_delete","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"删除（按钮）","menuType":"按钮"}  id: btn:saleTransform_delete', N'127.0.0.1', N'2022-05-10 16:57:55.9620000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523950521271914498', N'系统管理员', N'修改菜单', N'6', N'com.xmb.wcapi.controller.MenuController.edit()', N'  sysMenu: SysMenu [id=5c7c36904e004e98b61fefb321c6a6a8, menuName=采购到货列表, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/purchase_arrival/index, menuIcon=, orderByIndex=2]', N'127.0.0.1', N'2022-05-10 16:58:12.5590000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523951377883009027', N'系统管理员', N'添加菜单', N'13', N'com.xmb.wcapi.controller.MenuController.add()', N'  sysMenu: SysMenu [id=1523951377883009026, menuName=采购到货, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/purchase_arrival/index, menuIcon=, orderByIndex=1]', N'127.0.0.1', N'2022-05-10 17:01:36.7980000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523951476453347330', N'系统管理员', N'修改菜单', N'7', N'com.xmb.wcapi.controller.MenuController.edit()', N'  sysMenu: SysMenu [id=5c7c36904e004e98b61fefb321c6a6a8, menuName=采购到货列表, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/purchase_arrival_list/index, menuIcon=, orderByIndex=2]', N'127.0.0.1', N'2022-05-10 17:02:00.2950000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523951577422827522', N'系统管理员', N'修改按钮', N'3', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:purchaseArrivalList_delete","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"删除（按钮）","menuType":"按钮"}  id: btn:purchaseArrival_delete', N'127.0.0.1', N'2022-05-10 17:02:24.3710000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523951624965263362', N'系统管理员', N'修改按钮', N'2', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:purchaseArrivalList_update","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"修改（按钮）","menuType":"按钮"}  id: btn:purchaseArrival_update', N'127.0.0.1', N'2022-05-10 17:02:35.7050000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523951733627097089', N'系统管理员', N'修改按钮', N'2', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:purchaseArrivalList_view","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"页面查看","menuType":"按钮"}  id: btn:purchaseArrival_view', N'127.0.0.1', N'2022-05-10 17:03:01.6180000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523951961423941633', N'系统管理员', N'添加菜单', N'7', N'com.xmb.wcapi.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:purchaseArrival_comfire, menuName=确认（按钮）, supperId=1523951377883009026, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-05-10 17:03:55.9180000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523952032110546945', N'系统管理员', N'添加菜单', N'1', N'com.xmb.wcapi.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:purchaseArrival_view, menuName=页面查看, supperId=1523951377883009026, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-05-10 17:04:12.7760000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1523954271734665217', N'系统管理员', N'权限赋权', N'20', N'com.xmb.wcapi.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","1523951377883009026","btn:purchaseArrival_comfire","btn:purchaseArrival_view","5c7c36904e004e98b61fefb321c6a6a8","btn:purchaseArrivalList_delete","btn:purchaseArrivalList_update","btn:purchaseArrivalList_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_delete","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-05-10 17:13:06.7320000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1524238065737814018', N'系统管理员', N'权限赋权', N'82', N'com.xmb.wcapi.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","1523951377883009026","btn:purchaseArrival_view","5c7c36904e004e98b61fefb321c6a6a8","btn:purchaseArrivalList_delete","btn:purchaseArrivalList_update","btn:purchaseArrivalList_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_delete","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-05-11 12:00:48.5040000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1524238191571128355', N'系统管理员', N'权限赋权', N'11', N'com.xmb.wcapi.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","1523951377883009026","btn:purchaseArrival_comfire","btn:purchaseArrival_view","5c7c36904e004e98b61fefb321c6a6a8","btn:purchaseArrivalList_delete","btn:purchaseArrivalList_update","btn:purchaseArrivalList_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_delete","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-05-11 12:01:18.5100000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526382745887895553', N'系统管理员', N'修改菜单', N'19', N'com.xmb.wcapi.controller.MenuController.edit()', N'  sysMenu: SysMenu [id=5c7c36904e004e98b61fefb321c6a6a8, menuName=成品送货列表, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/product_delivery/index, menuIcon=, orderByIndex=2]', N'127.0.0.1', N'2022-05-17 10:03:00.0820000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526382837143367681', N'系统管理员', N'修改按钮', N'7', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:productDelivery_update","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"修改（按钮）","menuType":"按钮"}  id: btn:purchaseArrivalList_update', N'127.0.0.1', N'2022-05-17 10:03:21.8650000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526382885008764930', N'系统管理员', N'修改按钮', N'2', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:productDelivery_delete","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"删除（按钮）","menuType":"按钮"}  id: btn:purchaseArrivalList_delete', N'127.0.0.1', N'2022-05-17 10:03:33.2680000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526382941044666369', N'系统管理员', N'修改按钮', N'3', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:productDelivery_view","supperId":"5c7c36904e004e98b61fefb321c6a6a8","menuName":"页面查看","menuType":"按钮"}  id: btn:purchaseArrivalList_view', N'127.0.0.1', N'2022-05-17 10:03:46.6370000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526383050876710913', N'系统管理员', N'添加菜单', N'3', N'com.xmb.wcapi.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:productDelivery_add, menuName=新增（按钮）, supperId=5c7c36904e004e98b61fefb321c6a6a8, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-05-17 10:04:12.8130000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526383158448025602', N'系统管理员', N'权限赋权', N'22', N'com.xmb.wcapi.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","1523951377883009026","btn:purchaseArrival_comfire","btn:purchaseArrival_view","5c7c36904e004e98b61fefb321c6a6a8","btn:productDelivery_add","btn:productDelivery_delete","btn:productDelivery_update","btn:productDelivery_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_delete","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-05-17 10:04:38.4590000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526384856331644929', N'系统管理员', N'添加菜单', N'10', N'com.xmb.wcapi.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:productDelivery_print, menuName=打印（按钮）, supperId=5c7c36904e004e98b61fefb321c6a6a8, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-05-17 10:11:23.2680000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1526842255072964609', N'系统管理员', N'权限赋权', N'12', N'com.xmb.wcapi.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","1523951377883009026","btn:purchaseArrival_comfire","btn:purchaseArrival_view","5c7c36904e004e98b61fefb321c6a6a8","btn:productDelivery_add","btn:productDelivery_delete","btn:productDelivery_print","btn:productDelivery_update","btn:productDelivery_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_delete","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-05-18 16:28:55.6120000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1527124551449587714', N'系统管理员', N'修改菜单', N'8', N'com.xmb.wcapi.controller.MenuController.edit()', N'  sysMenu: SysMenu [id=d69ba7f67d094c28a5b6f7410ba99433, menuName=采购转换, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/product_arrival/index, menuIcon=, orderByIndex=3]', N'127.0.0.1', N'2022-05-19 11:10:40.3150000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1527124705472819201', N'系统管理员', N'修改按钮', N'5', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:productArrival_comfire","supperId":"d69ba7f67d094c28a5b6f7410ba99433","menuName":"确认（按钮）","menuType":"按钮"}  id: btn:purchaseTransform_delete', N'127.0.0.1', N'2022-05-19 11:11:17.0470000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1527124784380260353', N'系统管理员', N'修改按钮', N'20', N'com.xmb.wcapi.controller.MenuController.editBtn()', N'  data: {"id":"btn:productArrival_view","supperId":"d69ba7f67d094c28a5b6f7410ba99433","menuName":"页面查看","menuType":"按钮"}  id: btn:purchaseTransform_view', N'127.0.0.1', N'2022-05-19 11:11:35.8610000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1527126535099527170', N'系统管理员', N'权限赋权', N'11', N'com.xmb.wcapi.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","1523951377883009026","btn:purchaseArrival_comfire","btn:purchaseArrival_view","5c7c36904e004e98b61fefb321c6a6a8","btn:productDelivery_add","btn:productDelivery_delete","btn:productDelivery_print","btn:productDelivery_update","btn:productDelivery_view","d69ba7f67d094c28a5b6f7410ba99433","btn:productArrival_comfire","btn:productArrival_view"]', N'127.0.0.1', N'2022-05-19 11:18:33.2630000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1527126723365056513', N'系统管理员', N'修改菜单', N'3', N'com.xmb.wcapi.controller.MenuController.edit()', N'  sysMenu: SysMenu [id=d69ba7f67d094c28a5b6f7410ba99433, menuName=成品到货, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/product_arrival/index, menuIcon=, orderByIndex=3]', N'127.0.0.1', N'2022-05-19 11:19:18.1500000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528643591506685954', N'系统管理员', N'添加用户', N'14', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1528643591372468226, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=3d23a3270f434b6089bfacd6d818c261, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=5d5b6cd779e22ab3c194c6f6933a7465, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 15:46:47.6810000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528643789523972097', N'系统管理员', N'删除用户', N'11', N'com.xmb.wcapi.controller.UserController.update()', N'  ids: [1528643591372468226]', N'127.0.0.1', N'2022-05-23 15:47:34.9100000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528643857626886147', N'系统管理员', N'添加用户', N'3', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1528643857626886146, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=5d5b6cd779e22ab3c194c6f6933a7465, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 15:47:51.1490000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528644006394654722', N'系统管理员', N'删除用户', N'1', N'com.xmb.wcapi.controller.UserController.update()', N'  ids: [1528643857626886146]', N'127.0.0.1', N'2022-05-23 15:48:26.6270000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528644984846086147', N'系统管理员', N'添加用户', N'3', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1528644984846086146, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=5d5b6cd779e22ab3c194c6f6933a7465, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 15:52:19.9090000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528645248856551425', N'系统管理员', N'删除用户', N'1', N'com.xmb.wcapi.controller.UserController.update()', N'  ids: [1528644984846086146]', N'127.0.0.1', N'2022-05-23 15:53:22.8500000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528645331715026946', N'系统管理员', N'添加用户', N'4', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=5d5b6cd779e22ab3c194c6f6933a7465, createUser=null, createTime=null, updateTime=null, erpSupplier=01001, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 15:53:42.5970000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528665324582268930', N'系统管理员', N'修改用户', N'8', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=01001, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:13:09.2640000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528665931674218497', N'系统管理员', N'修改用户', N'4', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=01001, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:15:34.0050000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528665975546638338', N'系统管理员', N'修改用户', N'3', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:15:44.4720000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528667596565442562', N'系统管理员', N'修改用户', N'4', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=01001, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:22:10.9470000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528667633034915841', N'系统管理员', N'修改用户', N'4', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:22:19.6570000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528667828195880962', N'系统管理员', N'修改用户', N'19', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528645331715026945, userCode=1, userName=1, userPhone=1, userAge=1, userSex=男, userAddr=1, userEmail=1, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=01001, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:23:06.1630000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528667909603127298', N'系统管理员', N'添加用户', N'5', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1528667909603127297, userCode=2, userName=2, userPhone=2, userAge=2, userSex=男, userAddr=2, userEmail=2, departmentId=99f385f20e1e480a9f573a741c693342, roleId=76d471c4091c45ebaa8ebe58459c092c, openId=null, userPassword=ebec2a46e3a54b78faf9ca2a3f6378b1, createUser=null, createTime=null, updateTime=null, erpSupplier=null, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:23:25.5870000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1528670739072217090', N'系统管理员', N'修改用户', N'3', N'com.xmb.wcapi.controller.UserController.update()', N'  user: SysUser(id=1528667909603127297, userCode=2, userName=2, userPhone=2, userAge=2, userSex=男, userAddr=2, userEmail=2, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=null, createUser=null, createTime=null, updateTime=null, erpSupplier=01002, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-23 17:34:40.1930000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531450608138985474', N'系统管理员', N'删除用户', N'7', N'com.xmb.wcapi.controller.UserController.update()', N'  ids: [1518871656954466306, 1518873861648420865, 1528645331715026945, 1528667909603127297]', N'127.0.0.1', N'2022-05-31 09:40:52.5990000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531450930328641537', N'系统管理员', N'添加用户', N'18', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1531450930311864321, userCode=18623008323, userName=李洪罡, userPhone=18623008323, userAge=11, userSex=男, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=115984b3b7ee36b3feccdb471af8e004, createUser=null, createTime=null, updateTime=null, erpSupplier=01001, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-31 09:42:09.4290000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531451143541891074', N'系统管理员', N'添加用户', N'7', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1531451143525113858, userCode=13368136883, userName=冉红云, userPhone=13368136883, userAge=11, userSex=男, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=c79b31b0f9e24f7413976c69a016215f, createUser=null, createTime=null, updateTime=null, erpSupplier=01002, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-31 09:43:00.2650000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531451500900786177', N'系统管理员', N'添加用户', N'5', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1531451500888203266, userCode=18580255918, userName=黄勇, userPhone=18580255918, userAge=11, userSex=男, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=2b40c32d16253e8b57489275e2f9d08d, createUser=null, createTime=null, updateTime=null, erpSupplier=01003, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-31 09:44:25.4640000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531451796053958658', N'系统管理员', N'添加用户', N'18', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1531451796053958657, userCode=18723196226, userName=何杰, userPhone=18723196226, userAge=11, userSex=女, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=a98c8df7dd0a83a0e98f70fb956fbff9, createUser=null, createTime=null, updateTime=null, erpSupplier=01004, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-31 09:45:35.8360000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531451962408443905', N'系统管理员', N'添加用户', N'5', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1531451962391666689, userCode=18342217396, userName=李能, userPhone=18342217396, userAge=11, userSex=男, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=809141fc4a33cbe0ca31049536210eb0, createUser=null, createTime=null, updateTime=null, erpSupplier=01005, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-31 09:46:15.4960000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'1531452233213681667', N'系统管理员', N'添加用户', N'15', N'com.xmb.wcapi.controller.UserController.add()', N'  user: SysUser(id=1531452233213681666, userCode=15985230454, userName=小黎, userPhone=15985230454, userAge=11, userSex=女, userAddr=11, userEmail=11, departmentId=99f385f20e1e480a9f573a741c693342, roleId=b815f08c91734cf3a0e2c7023a5d3035, openId=null, userPassword=84387b9722de3eb8f5594845df82ad18, createUser=null, createTime=null, updateTime=null, erpSupplier=01006, departmentName=null, roleName=null)', N'127.0.0.1', N'2022-05-31 09:47:20.0660000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'4070b92aa9e84ee9b7462991152ea41e', N'系统管理员', N'权限赋权', N'16', N'com.xmb.transfer.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","5c7c36904e004e98b61fefb321c6a6a8","btn:saleTransform_scale","btn:saleTransform_transfer","btn:saleTransform_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-01-12 09:55:57.3460000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'4a799efeda8d4b3e9c3f871636ca732a', N'系统管理员', N'添加菜单', N'4', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:saleTransform_scale, menuName=分配率（按钮）, supperId=5c7c36904e004e98b61fefb321c6a6a8, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-01-12 09:55:47.1680000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'5cadf24370ab4adf8e112ddc091e23e6', N'系统管理员', N'添加菜单', N'7', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:saleTransform_delete, menuName=删除（按钮）, supperId=d69ba7f67d094c28a5b6f7410ba99433, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-03-29 10:36:49.7200000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'5d25aafe63ff4cd3af7d645efccf2560', N'系统管理员', N'添加菜单', N'216', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=b62e0dfefa1a40c8b9690538b33cfb87, menuName=业务工作, supperId=, menuType=菜单, menuUrl=, menuIcon=, orderByIndex=3]', N'127.0.0.1', N'2021-12-30 11:49:12.3860000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'80cda0c864044fcca45631777c98682d', N'系统管理员', N'修改按钮', N'68', N'com.xmb.transfer.controller.MenuController.editBtn()', N'  data: {"id":"btn:purchaseTransform_delete","supperId":"d69ba7f67d094c28a5b6f7410ba99433","menuName":"删除（按钮）","menuType":"按钮"}  id: btn:saleTransform_delete', N'127.0.0.1', N'2022-03-29 10:37:16.2430000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'939f880e9153442f88f6c60b58258444', N'系统管理员', N'添加菜单', N'2', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:saleTransform_transfer, menuName=传输（按钮）, supperId=5c7c36904e004e98b61fefb321c6a6a8, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2021-12-30 11:55:35.4450000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'985705cbb8d64478b98799052ae5985f', N'系统管理员', N'权限赋权', N'73', N'com.xmb.transfer.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","5c7c36904e004e98b61fefb321c6a6a8","btn:saleTransform_transfer","btn:saleTransform_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2021-12-30 11:55:47.0530000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'a29fcb56e12740f09251503c220c6ff5', N'系统管理员', N'添加菜单', N'3', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:saleTransform_delete, menuName=删除（按钮）, supperId=5c7c36904e004e98b61fefb321c6a6a8, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2022-03-29 10:37:39.2510000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'afc507af5f1b466580a1ff318ac5e574', N'系统管理员', N'添加菜单', N'2', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:saleTransform_view, menuName=页面查看, supperId=5c7c36904e004e98b61fefb321c6a6a8, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2021-12-30 11:55:10.8340000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'beb4024da0f64edfa88334ccf22c87e4', N'系统管理员', N'添加菜单', N'3', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:purchaseTransform_view, menuName=页面查看, supperId=d69ba7f67d094c28a5b6f7410ba99433, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2021-12-30 11:52:18.3560000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'c40a56bdc5114460b526af23ffe87f04', N'系统管理员', N'添加角色', N'218', N'com.xmb.transfer.controller.PermissionController.addRole()', N'  sysRole: SysRole{, id=b815f08c91734cf3a0e2c7023a5d3035, roleCode=supplier, roleName=供应商, createTime=null, updateTime=null, pid=null}', N'127.0.0.1', N'2021-12-30 10:59:32.5910000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'dda1de4efcf4421cbd5065b92ac090ba', N'系统管理员', N'权限赋权', N'22', N'com.xmb.transfer.controller.PermissionController.comfire_permission()', N'  roleId: 76d471c4091c45ebaa8ebe58459c092c  permissionIds: [111,11101,"btn:permission_addPermission","btn:permission_addRole","btn:permission_deleteRole","btn:permission_editRole","btn:permission_view",11102,"btn:menu_addBase","btn:menu_addBtn","btn:menu_addSub","btn:menu_edit","btn:menu_view","1127853eba334e6589e2ecb4d3b61a2b","btn:dept_addBase","btn:dept_addSub","btn:dept_delete","btn:dept_edit","btn:dept_view","d072460c4e1a4722a94462730e8977c4","btn:user_add","btn:user_delete","btn:user_edit","btn:user_view","53759f94727642a9b7189ae438f5b7c3","b62e0dfefa1a40c8b9690538b33cfb87","5c7c36904e004e98b61fefb321c6a6a8","btn:saleTransform_delete","btn:saleTransform_scale","btn:saleTransform_transfer","btn:saleTransform_view","d69ba7f67d094c28a5b6f7410ba99433","btn:purchaseTransform_delete","btn:purchaseTransform_transfer","btn:purchaseTransform_view"]', N'127.0.0.1', N'2022-03-29 10:37:54.9370000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'e089f0e212854f149a4192feec3f99de', N'系统管理员', N'添加菜单', N'13', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=d69ba7f67d094c28a5b6f7410ba99433, menuName=采购转换, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/purchase_transform/index, menuIcon=, orderByIndex=1]', N'127.0.0.1', N'2021-12-30 11:51:28.8580000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'f9e0b479d5374b199d5aa4dcd8c45fe7', N'系统管理员', N'添加菜单', N'1', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=btn:purchaseTransform_transfer, menuName=传输（按钮）, supperId=d69ba7f67d094c28a5b6f7410ba99433, menuType=按钮, menuUrl=null, menuIcon=null, orderByIndex=null]', N'127.0.0.1', N'2021-12-30 11:53:08.3780000')
GO

INSERT INTO [dbo].[sys_log] VALUES (N'fa554afd584c40ef915a761f0609cea1', N'系统管理员', N'添加菜单', N'17', N'com.xmb.transfer.controller.MenuController.add()', N'  sysMenu: SysMenu [id=5c7c36904e004e98b61fefb321c6a6a8, menuName=销售转换, supperId=b62e0dfefa1a40c8b9690538b33cfb87, menuType=菜单, menuUrl=/manage/sale_transform/index, menuIcon=, orderByIndex=2]', N'127.0.0.1', N'2021-12-30 11:54:26.3260000')
GO


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_menu]
GO

CREATE TABLE [dbo].[sys_menu] (
  [id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [menu_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [supper_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [menu_type] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [menu_url] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [menu_icon] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [order_by_index] nvarchar(3) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_menu] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO [dbo].[sys_menu] VALUES (N'111', N'系统设置', N'', N'菜单', N'', N'', N'1')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'11101', N'权限管理', N'111', N'菜单', N'/permission/index', N'', N'4')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'11102', N'菜单管理', N'111', N'菜单', N'/menu/index', N'', N'3')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'1127853eba334e6589e2ecb4d3b61a2b', N'部门管理', N'111', N'菜单', N'/department/index', N'', N'2')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'1523951377883009026', N'采购到货', N'b62e0dfefa1a40c8b9690538b33cfb87', N'菜单', N'/manage/purchase_arrival/index', N'', N'1')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'53759f94727642a9b7189ae438f5b7c3', N'基础档案', N'', N'菜单', N'', N'', N'2')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'5c7c36904e004e98b61fefb321c6a6a8', N'成品送货列表', N'b62e0dfefa1a40c8b9690538b33cfb87', N'菜单', N'/manage/product_delivery/index', N'', N'2')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'b62e0dfefa1a40c8b9690538b33cfb87', N'业务工作', N'', N'菜单', N'', N'', N'3')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:dept_addBase', N'新增根部门(按钮)', N'1127853eba334e6589e2ecb4d3b61a2b', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:dept_addSub', N'新增子部门(按钮)', N'1127853eba334e6589e2ecb4d3b61a2b', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:dept_delete', N'删除(按钮)', N'1127853eba334e6589e2ecb4d3b61a2b', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:dept_edit', N'修改(按钮)', N'1127853eba334e6589e2ecb4d3b61a2b', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:dept_view', N'页面查看', N'1127853eba334e6589e2ecb4d3b61a2b', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:menu_addBase', N'新增根节点(按钮)', N'11102', N'按钮', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:menu_addBtn', N'新增子节点(按钮)', N'11102', N'按钮', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:menu_addSub', N'新增子节点(按钮)', N'11102', N'按钮', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:menu_edit', N'修改(按钮)', N'11102', N'按钮', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:menu_view', N'页面查看', N'11102', N'按钮', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:permission_addPermission', N'确认赋权(按钮)', N'11101', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:permission_addRole', N'新增角色(按钮)', N'11101', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:permission_deleteRole', N'删除角色(按钮)', N'11101', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:permission_editRole', N'修改角色(按钮)', N'11101', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:permission_view', N'页面查看', N'11101', N'按钮', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productArrival_comfire', N'确认（按钮）', N'd69ba7f67d094c28a5b6f7410ba99433', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productArrival_view', N'页面查看', N'd69ba7f67d094c28a5b6f7410ba99433', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productDelivery_add', N'新增（按钮）', N'5c7c36904e004e98b61fefb321c6a6a8', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productDelivery_delete', N'删除（按钮）', N'5c7c36904e004e98b61fefb321c6a6a8', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productDelivery_print', N'打印（按钮）', N'5c7c36904e004e98b61fefb321c6a6a8', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productDelivery_update', N'修改（按钮）', N'5c7c36904e004e98b61fefb321c6a6a8', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:productDelivery_view', N'页面查看', N'5c7c36904e004e98b61fefb321c6a6a8', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:purchaseArrival_comfire', N'确认（按钮）', N'1523951377883009026', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:purchaseArrival_view', N'页面查看', N'1523951377883009026', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:user_add', N'新增(按钮)', N'd072460c4e1a4722a94462730e8977c4', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:user_delete', N'删除(按钮)', N'd072460c4e1a4722a94462730e8977c4', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:user_edit', N'修改(按钮)', N'd072460c4e1a4722a94462730e8977c4', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'btn:user_view', N'页面查看', N'd072460c4e1a4722a94462730e8977c4', N'按钮', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'd072460c4e1a4722a94462730e8977c4', N'用户管理', N'111', N'菜单', N'/user/index', N'', N'1')
GO

INSERT INTO [dbo].[sys_menu] VALUES (N'd69ba7f67d094c28a5b6f7410ba99433', N'成品到货', N'b62e0dfefa1a40c8b9690538b33cfb87', N'菜单', N'/manage/product_arrival/index', N'', N'3')
GO


-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role]
GO

CREATE TABLE [dbo].[sys_role] (
  [id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [role_code] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [role_name] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [pid] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(0)  NULL,
  [update_time] datetime2(0)  NULL
)
GO

ALTER TABLE [dbo].[sys_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色代码',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'role_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'role_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父级角色ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'pid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色表',
'SCHEMA', N'dbo',
'TABLE', N'sys_role'
GO


-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO [dbo].[sys_role] VALUES (N'76d471c4091c45ebaa8ebe58459c092c', N'system', N'系统管理员---', NULL, N'2020-03-11 12:03:32', N'2021-05-11 11:17:52')
GO

INSERT INTO [dbo].[sys_role] VALUES (N'b815f08c91734cf3a0e2c7023a5d3035', N'supplier', N'供应商', NULL, NULL, NULL)
GO


-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_permission]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role_permission]
GO

CREATE TABLE [dbo].[sys_role_permission] (
  [id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [role_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [permission_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_user] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(0)  NULL,
  [update_user] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(0)  NULL
)
GO

ALTER TABLE [dbo].[sys_role_permission] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195521', N'76d471c4091c45ebaa8ebe58459c092c', N'111', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195522', N'76d471c4091c45ebaa8ebe58459c092c', N'11101', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195523', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:permission_addPermission', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195524', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:permission_addRole', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195525', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:permission_deleteRole', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195526', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:permission_editRole', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535049195527', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:permission_view', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778433', N'76d471c4091c45ebaa8ebe58459c092c', N'11102', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778434', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:menu_addBase', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778435', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:menu_addBtn', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778436', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:menu_addSub', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778437', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:menu_edit', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778438', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:menu_view', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778439', N'76d471c4091c45ebaa8ebe58459c092c', N'1127853eba334e6589e2ecb4d3b61a2b', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778440', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:dept_addBase', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778441', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:dept_addSub', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778442', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:dept_delete', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778443', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:dept_edit', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778444', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:dept_view', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778445', N'76d471c4091c45ebaa8ebe58459c092c', N'd072460c4e1a4722a94462730e8977c4', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778446', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:user_add', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778447', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:user_delete', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778448', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:user_edit', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778449', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:user_view', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778450', N'76d471c4091c45ebaa8ebe58459c092c', N'53759f94727642a9b7189ae438f5b7c3', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778451', N'76d471c4091c45ebaa8ebe58459c092c', N'b62e0dfefa1a40c8b9690538b33cfb87', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778452', N'76d471c4091c45ebaa8ebe58459c092c', N'1523951377883009026', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778453', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:purchaseArrival_comfire', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778454', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:purchaseArrival_view', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778455', N'76d471c4091c45ebaa8ebe58459c092c', N'5c7c36904e004e98b61fefb321c6a6a8', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778456', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productDelivery_add', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778457', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productDelivery_delete', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778458', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productDelivery_print', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778459', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productDelivery_update', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778460', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productDelivery_view', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778461', N'76d471c4091c45ebaa8ebe58459c092c', N'd69ba7f67d094c28a5b6f7410ba99433', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778462', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productArrival_comfire', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role_permission] VALUES (N'1527126535061778463', N'76d471c4091c45ebaa8ebe58459c092c', N'btn:productArrival_view', NULL, NULL, NULL, NULL)
GO


-- ----------------------------
-- Table structure for sys_settings
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_settings]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_settings]
GO

CREATE TABLE [dbo].[sys_settings] (
  [project] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [status] bit  NULL,
  [describe] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_settings] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目',
'SCHEMA', N'dbo',
'TABLE', N'sys_settings',
'COLUMN', N'project'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'sys_settings',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'文字描述',
'SCHEMA', N'dbo',
'TABLE', N'sys_settings',
'COLUMN', N'describe'
GO


-- ----------------------------
-- Records of sys_settings
-- ----------------------------
INSERT INTO [dbo].[sys_settings] VALUES (N'verify', N'1', N'单据自动审核')
GO


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user]
GO

CREATE TABLE [dbo].[sys_user] (
  [id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [user_code] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_phone] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_age] int  NULL,
  [user_sex] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_addr] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_email] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [department_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [role_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [open_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_password] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_user] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(0)  NULL,
  [update_time] datetime2(0)  NULL,
  [erp_supplier] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户账号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'电话',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_phone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'年龄',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_age'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_sex'
GO

EXEC sp_addextendedproperty
'MS_Description', N'地址',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_addr'
GO

EXEC sp_addextendedproperty
'MS_Description', N'邮箱',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门id',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'department_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'role_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'微信openid',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'open_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'user_password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'create_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'ERP供应商编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'erp_supplier'
GO


-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO [dbo].[sys_user] VALUES (N'111', N'admin', N'系统管理员', NULL, NULL, NULL, NULL, NULL, N'99f385f20e1e480a9f573a741c693342', N'76d471c4091c45ebaa8ebe58459c092c', NULL, N'928bfd2577490322a6e19b793691467e', NULL, N'2020-03-11 14:05:35', N'2021-01-13 10:06:28', NULL)
GO

INSERT INTO [dbo].[sys_user] VALUES (N'1531450930311864321', N'18623008323', N'李洪罡', N'18623008323', N'11', N'男', N'11', N'11', N'99f385f20e1e480a9f573a741c693342', N'b815f08c91734cf3a0e2c7023a5d3035', NULL, N'115984b3b7ee36b3feccdb471af8e004', NULL, NULL, NULL, N'01001')
GO

INSERT INTO [dbo].[sys_user] VALUES (N'1531451143525113858', N'13368136883', N'冉红云', N'13368136883', N'11', N'男', N'11', N'11', N'99f385f20e1e480a9f573a741c693342', N'b815f08c91734cf3a0e2c7023a5d3035', NULL, N'c79b31b0f9e24f7413976c69a016215f', NULL, NULL, NULL, N'01002')
GO

INSERT INTO [dbo].[sys_user] VALUES (N'1531451500888203266', N'18580255918', N'黄勇', N'18580255918', N'11', N'男', N'11', N'11', N'99f385f20e1e480a9f573a741c693342', N'b815f08c91734cf3a0e2c7023a5d3035', NULL, N'2b40c32d16253e8b57489275e2f9d08d', NULL, NULL, NULL, N'01003')
GO

INSERT INTO [dbo].[sys_user] VALUES (N'1531451796053958657', N'18723196226', N'何杰', N'18723196226', N'11', N'女', N'11', N'11', N'99f385f20e1e480a9f573a741c693342', N'b815f08c91734cf3a0e2c7023a5d3035', NULL, N'a98c8df7dd0a83a0e98f70fb956fbff9', NULL, NULL, NULL, N'01004')
GO

INSERT INTO [dbo].[sys_user] VALUES (N'1531451962391666689', N'18342217396', N'李能', N'18342217396', N'11', N'男', N'11', N'11', N'99f385f20e1e480a9f573a741c693342', N'b815f08c91734cf3a0e2c7023a5d3035', NULL, N'809141fc4a33cbe0ca31049536210eb0', NULL, NULL, NULL, N'01005')
GO

INSERT INTO [dbo].[sys_user] VALUES (N'1531452233213681666', N'15985230454', N'小黎', N'15985230454', N'11', N'女', N'11', N'11', N'99f385f20e1e480a9f573a741c693342', N'b815f08c91734cf3a0e2c7023a5d3035', NULL, N'84387b9722de3eb8f5594845df82ad18', NULL, NULL, NULL, N'01006')
GO


-- ----------------------------
-- Table structure for wms_product_delivery_detail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[wms_product_delivery_detail]') AND type IN ('U'))
	DROP TABLE [dbo].[wms_product_delivery_detail]
GO

CREATE TABLE [dbo].[wms_product_delivery_detail] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [master_id] char(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [cinvCode] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [current_delivery_qty] int  NULL,
  [reciept_qty] int  NULL,
  [cbatch] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [product_code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [product_master_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [product_detail_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[wms_product_delivery_detail] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主表id',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'master_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存货编码',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'cinvCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数量',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'current_delivery_qty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'实收数量',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'reciept_qty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'批次',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'cbatch'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产订单号',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'product_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产订单主表id',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'product_master_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产订单子表id',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_detail',
'COLUMN', N'product_detail_id'
GO


-- ----------------------------
-- Records of wms_product_delivery_detail
-- ----------------------------
INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527096852240805890             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702923', N'200', N'200', N'1', N'S220221-2', N'1000008757', N'1000169433')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962817             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702923', N'100', N'100', N'1', N'S220221-2', N'1000008757', N'1000169432')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962818             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702893', N'200', N'200', N'2', N'S220221-2', N'1000008757', N'1000169437')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962819             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702893', N'300', N'300', N'3', N'S220221-2', N'1000008757', N'1000169436')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962820             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'7021044', N'400', N'400', N'4', N'S220221-2', N'1000008757', N'1000169435')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962821             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'7021044', N'500', N'500', N'5', N'S220221-2', N'1000008757', N'1000169434')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962822             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702886', N'600', N'600', N'6', N'S220220-2', N'1000008756', N'1000169423')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106275612962823             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'7021044', N'560', N'560', N'7', N'S220220-2', N'1000008756', N'1000169424')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462658             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702028', N'100', N'100', N'1', N'S220220-2', N'1000008756', N'1000169426')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462659             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'702893', N'200', N'200', N'2', N'S220220-2', N'1000008756', N'1000169425')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462660             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'317067', N'300', N'300', N'2', N'S220220-1', N'1000008755', N'1000169416')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462661             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'314009', N'400', N'400', N'3', N'S220220-1', N'1000008755', N'1000169421')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462662             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'315165', N'20', N'20', N'4', N'S220220-1', N'1000008755', N'1000169422')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462663             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'317072', N'300', N'300', N'5', N'S220220-1', N'1000008755', N'1000169417')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462664             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'317073', N'200', N'200', N'6', N'S220220-1', N'1000008755', N'1000169418')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527106927659462665             ', N'3a2b820477da4d0f8c43947ea5c5bc6c', N'323925', N'100', N'100', N'7', N'S220220-1', N'1000008755', N'1000169419')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527563900666441730             ', N'b9febcc19faa446d9992a48aa64bf2ba', N'702028', N'150', N'150', N'111', N'S220219-2', N'1000008754', N'1000169410')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527563900666441731             ', N'b9febcc19faa446d9992a48aa64bf2ba', N'702028', N'250', N'250', N'222', N'S220219-2', N'1000008754', N'1000169409')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527563900666441732             ', N'b9febcc19faa446d9992a48aa64bf2ba', N'702893', N'350', N'350', N'333', N'S220219-2', N'1000008754', N'1000169408')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1527563900666441733             ', N'b9febcc19faa446d9992a48aa64bf2ba', N'702893', N'450', N'450', N'444', N'S220219-2', N'1000008754', N'1000169407')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1528549185508274177             ', N'13f9d60214b445bfa75048f63e9b9b95', N'702923', N'500', N'500', N'20220523', N'S220221-2', N'1000008757', N'1000169432')
GO

INSERT INTO [dbo].[wms_product_delivery_detail] VALUES (N'1528549185508274178             ', N'13f9d60214b445bfa75048f63e9b9b95', N'702893', N'400', N'400', N'20220523', N'S220221-2', N'1000008757', N'1000169437')
GO


-- ----------------------------
-- Table structure for wms_product_delivery_master
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[wms_product_delivery_master]') AND type IN ('U'))
	DROP TABLE [dbo].[wms_product_delivery_master]
GO

CREATE TABLE [dbo].[wms_product_delivery_master] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [delivery_code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [cwhCode] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_user] char(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_date] datetime  NULL,
  [create_date_str] char(10) COLLATE Chinese_PRC_CI_AS  NULL,
  [memo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [complete_flag] bit  NULL
)
GO

ALTER TABLE [dbo].[wms_product_delivery_master] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'送货单号',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'delivery_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'仓库编码',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'cwhCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'制单人',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'create_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'制单日期',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'create_date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'制单日期（xxxx-xx-xx）',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'create_date_str'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'memo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接收状态（1：接收，0：未接收）',
'SCHEMA', N'dbo',
'TABLE', N'wms_product_delivery_master',
'COLUMN', N'complete_flag'
GO


-- ----------------------------
-- Records of wms_product_delivery_master
-- ----------------------------
INSERT INTO [dbo].[wms_product_delivery_master] VALUES (N'13f9d60214b445bfa75048f63e9b9b95', N'PA2205230001', N'05', N'111                             ', N'2022-05-23 09:31:39.527', N'2022-05-23', NULL, N'1')
GO

INSERT INTO [dbo].[wms_product_delivery_master] VALUES (N'3a2b820477da4d0f8c43947ea5c5bc6c', N'PA2205190001', N'05', N'111                             ', N'2022-05-19 09:20:36.310', N'2022-05-19', NULL, N'1')
GO

INSERT INTO [dbo].[wms_product_delivery_master] VALUES (N'b9febcc19faa446d9992a48aa64bf2ba', N'PA2205200001', N'05', N'111                             ', N'2022-05-20 16:16:29.300', N'2022-05-20', NULL, N'1')
GO


-- ----------------------------
-- Primary Key structure for table sp_delivery_details
-- ----------------------------
ALTER TABLE [dbo].[sp_delivery_details] ADD CONSTRAINT [PK__sp_deliv__3213E83F1BFD2C07] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sp_delivery_master
-- ----------------------------
ALTER TABLE [dbo].[sp_delivery_master] ADD CONSTRAINT [PK__sp_deliv__3213E83F182C9B23] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_dept
-- ----------------------------
ALTER TABLE [dbo].[sys_dept] ADD CONSTRAINT [PK__sys_dept__3213E83F09DE7BCC] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_log
-- ----------------------------
ALTER TABLE [dbo].[sys_log] ADD CONSTRAINT [PK__sys_log__3213E83F0CBAE877] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_menu
-- ----------------------------
ALTER TABLE [dbo].[sys_menu] ADD CONSTRAINT [PK__sys_menu__3213E83F0F975522] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_role
-- ----------------------------
ALTER TABLE [dbo].[sys_role] ADD CONSTRAINT [PK__sys_role__3213E83F1273C1CD] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_role_permission
-- ----------------------------
ALTER TABLE [dbo].[sys_role_permission] ADD CONSTRAINT [PK__sys_role__3213E83F15502E78] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_settings
-- ----------------------------
ALTER TABLE [dbo].[sys_settings] ADD CONSTRAINT [PK__sys_sett__A0D5F2B78EF86E2A] PRIMARY KEY CLUSTERED ([project])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_user
-- ----------------------------
ALTER TABLE [dbo].[sys_user] ADD CONSTRAINT [PK__sys_user__3213E83F182C9B23] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table wms_product_delivery_detail
-- ----------------------------
ALTER TABLE [dbo].[wms_product_delivery_detail] ADD CONSTRAINT [PK__wms_prod__3213E83FF9CFA413] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table wms_product_delivery_master
-- ----------------------------
ALTER TABLE [dbo].[wms_product_delivery_master] ADD CONSTRAINT [PK__wms_prod__3213E83FA303A246] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

